Questions tagged [csv]
Comma-separated values - a simple file format that stores tabular data (numbers and text) in plain-text form.
36
questions
1
vote
1
answer
46
views
How to nicely import CSV contacts to Google Contacts preserving as much information as possible?
I was looking at the help file for importing contacts to Google and it didn't specify how to organize the columns:
Company First Name Last Name Email Phone Mobile Street City State Zip ...
- 684
0
votes
0
answers
6
views
GA csv report and interface contain different users count data
We've implemented Google Analytics in app and I'm using csv reports to process events data.
I've noticed strange thing: users count in GA interface event report differs from users count in events ...
0
votes
1
answer
209
views
How to import only some of csv into Google Sheets
I'm trying to auto-import this huge csv file into Google Sheets, but when I use the importdata function, it tells me "Resource at URL contents exceeded maximum size." I'd like it to auto-...
- 1
0
votes
0
answers
343
views
Google Saved Places convert to custom Google Maps with takeout CSV
TLDR:
please help me and teach me how to import "takeout" CSV of "my saved places" into Google maps.
BTW I am a paid G-Suite organization, if that helps.
I have 128 lists (...
0
votes
1
answer
47
views
How do I make Google Music's exported music actually useful?
I've been using Google Play Music as a cloud library for years, not to find new music, but just to stream my existing music acquired and uploaded over the decades. Now the service is shutting down, ...
- 101
1
vote
0
answers
30
views
Is it possible to export reading time data in Perusall?
I am using Perusall to organize a university course. I want to export each student's average reading time in csv or other table format. Is it possible to do that? If yes, how? I can download a table ...
- 201
0
votes
2
answers
673
views
Google Sheets interpreting dates from CSV in a weird way
I'm opening a csv report in Google Sheets. The Google Drive preview shows the dates like this:
When I open this file in Google Sheets the dates now look like this:
And if I try and convert the date ...
- 31
0
votes
0
answers
33
views
Google Sheets CSV Download Loses Data from Other Worksheets
I'm trying to save a single sheet in Google Sheets to a CSV. In my example it's historical stock quotes formatted for Quicken import. All of the "work" is done in other sheets - specifying date ...
- 141
0
votes
2
answers
652
views
How to export CSV without commas in unpopulated cells?
I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website.
However, when I go to export, it seems ...
0
votes
3
answers
269
views
How to analyze a time tracking sheet with Google Sheets?
I have a simple time tracking set up with Tasker on my phone that creates a new line every time I connect to my work Wifi.
I upload this csv file regularly to Google Drive and import it to a Google ...
- 123
0
votes
1
answer
4k
views
Google App Script TypeError Cannot Call Method getSheets of null
Wondering if anyone can assist in debugging this Google app script. The script works as needed to create CSV files of each Sheet in my workbook, but it throws an error every time:
"TypeError: ...
- 13
0
votes
1
answer
1k
views
Sheets table from URL with pagination
I have a question about importing .csv/.xml tables from url into Google spreadsheets. Maybe someone has any advice on how to import few csv tables from url that has pagination? I could do it manually ...
- 5
0
votes
1
answer
606
views
Why doesn't this script populate sheet after parsing data from CSV file?
I got the below script which seems to work from time to time. It runs with no bugs reported, but it doesn't populate the sheet it is supposed to:
function importCSVFromWeb(url) {
// Provide the ...
2
votes
2
answers
6k
views
Importing "Reminders" to Google Calendar using CSV file
Google has added reminders in place of tasks on the calendar - very nice as they carry forward to the next day if not completed. I'd like to use these more as I have workflows that follow dates before ...
Gary
-1
votes
1
answer
103
views
Is there a way to rearrange columns of repeating sections in the exported CSV file?
I am using Cognito Forms to gather information about my worker's work progress for client billing purposes. They submit one form a day, but each work assignment gets filled out in a repeating section. ...
- 39
0
votes
1
answer
317
views
What's the equivalent of the SEP metadata in Google Sheets?
I'm using the SEP metadata in my csv files to enable people all over the world to correctly open them on MS Excel. It worked finely until recently some people wanted to open those files on Google ...
- 482
3
votes
1
answer
5k
views
Comma-separated values analysis and pivot tables in Google Spreadsheets
I have an issue with comma-separated values analysis and pivot tables in Google Spreadsheets. What if I have the following dataset:
Facebook, Github Developer
No answer Developer
...
- 33
1
vote
1
answer
49
views
Put quoutes around data in csv export from Google Spredsheets
I have about 200 rows each with 7 columns in Google Spreadsheets which I am exporting to csv, so that I can separate columns by comma and use this data in PHP arrays.
I get this
something, something,...
- 111
10
votes
1
answer
12k
views
How to use "split text to columns" when pasting in Google Sheets?
I have some CSV data in the clipboard that I'm trying to paste into a Google sheet (Chrome, Windows 7). There isn't really a direct paste option for CSV data (like the "Paste Unformatted Text" option ...
- 307
7
votes
2
answers
43k
views
Google Spreadsheets CSV Encoding not UTF-8?
I was assuming that Google spreadsheet exports UTF-8 encoded CSVs. However, this does not seem to be the case — my German Umlauts, etc. (äüöß, etc.) are not recognized, i.e., when opening the file in ...
- 203
8
votes
1
answer
15k
views
How can specific columns of a Google spreadsheet be exported as CSV?
I have a Google spreadsheet with 10 columns of data. I would like to export columns A, C, E, F as csv. I do not need to export the entire spreadsheet. Can this be done? I do not mind using Google ...
- 245
7
votes
2
answers
11k
views
IMPORTDATA Google Sheet CSV on Google Drive
So I'm starting to really get into utilizing Google Drive to streamline my many personal projects. One of the things I'd love to do is figure out how to download CSV files onto my Google Drive, and ...
- 151
2
votes
2
answers
5k
views
Parsing JSON, XML or CSV with IFTTT?
I'd like to create an IFTTT action that allows triggers based upon a certain electricity price threshold. This Xively feed can return the current price in either JSON, XML, or CSV formats. Xively's ...
- 867
2
votes
1
answer
3k
views
Import a CSV file from a URL to Google Sheets and update it periodically
I'm looking to pull data from a CSV file that gets update regularly into a Google spreadsheet that I can format the way I want. I know how to import the CSV as a one time thing but I don't know how to ...
MrCarter
1
vote
1
answer
1k
views
Auto import CSV into existing Google Sheet
I understand how to upload and convert CSV files to Google Sheets -- but how can I set up an automatic upload of all new data from a CSV file into an existing sheet?
I have a CSV file that lives on ...
- 11
0
votes
1
answer
2k
views
Import a CSV file to Google Spreadsheets
I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following:
hi,hello\r\nwelcome,to\r\npeaceful,world
What I expect in the Google spreadsheet is:
hi,...
- 1
12
votes
1
answer
15k
views
Export all sheets in a spreadsheet to csv in Google Apps
Is there a way to export all sheets in a google spreadsheet to csv as individual files ?
- 469
1
vote
1
answer
351
views
Can I get all contributions by users and export them in a csv file in MediaWiki?
From my MediaWiki site, I would like to get all the contributions by users in the last month in a csv file format. Is there any extension for this? Can I query the database and get this information?
- 19
2
votes
1
answer
4k
views
How to add carriage returns to CSV downloads?
In reference to this question:
Google Spreadsheet downloaded as CSV comes out on 1 line?, is there any way to have a downloaded Google Spreadsheets incorporate carriage returns and linefeeds such that ...
- 155
18
votes
2
answers
37k
views
Pull CSV data from URL to Google Spreadsheet
I have a site which allows authenticated users (read: in-house users) to download certain data from the site in CSV format, e.g. http://example.com/activities.csv . Can I create a Google Spreadsheet ...
- 283
4
votes
3
answers
8k
views
How to escape a double-quote in a TSV file for import into a Google Sheets?
How does one specify a cell to contain exactly one double-quote character in a TSV file so that it will be handled correctly when imported (as a spreadsheet) into Google Sheets?
(Note: when importing ...
- 429
41
votes
6
answers
69k
views
How to export a filtered set of rows from a Google Spreadsheet?
Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows?
I need to get in CSV exactly the rows which are visible on the sheet after a ...
- 519
2
votes
2
answers
6k
views
Is there a way to upload a .csv file to Google Docs using a Google Sheets as a template?
I am generating a .CSV file with an application.
I then upload the .CSV file to Google Docs, which creates a Google Docs Spreadsheet which is "plain and white".
I then have to manually format the .CSV ...
- 3,127
7
votes
2
answers
24k
views
What's the biggest .csv file you can import into a Google Sheets? [closed]
I'm trying to upload/import a 7 MB .csv file to Google Sheets without much luck.
What's the largest file size that you can import?
- 2,123
4
votes
2
answers
2k
views
No force-reload tip on Google Sheets?
So I'm running nightly tasks to generate some custom statistics for my site and copy the statistics in .csv format to separate server via SCP. Then I use these .csv files in Google Sheets to display ...
- 243
1
vote
2
answers
372
views
Changing the format of the CSV report download from Toggl
Can you change which values are included and how they are formatted, when you download a report as a CSV file from Toggl?
I would like to get the duration of the different tasks in a format that ...
- 715