Questions tagged [csv]

Comma-separated values - a simple file format that stores tabular data (numbers and text) in plain-text form.

Filter by
Sorted by
Tagged with
1 vote
1 answer
61 views

Downloading CSV results in empty (#ref) file. Is it a problem with IMPORTRANGE? [duplicate]

I have a multi sheet workbook in Google Sheets. I need to export a compilation of tables from this workbook to CSV. I therefore have added a new sheet where I use IMPORTRANGE to combine values from ...
d-b's user avatar
  • 1
1 vote
1 answer
2k views

How to nicely import CSV contacts to Google Contacts preserving as much information as possible? [duplicate]

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 ...
Thufir's user avatar
  • 696
0 votes
1 answer
244 views

How to import only some of csv into Google Sheets [closed]

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-...
Matthew's user avatar
  • 11
0 votes
1 answer
53 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, ...
jdc's user avatar
  • 101
1 vote
0 answers
31 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 ...
reflex0810's user avatar
0 votes
2 answers
899 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 ...
Westicle's user avatar
0 votes
0 answers
52 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 ...
Scott's user avatar
  • 151
0 votes
2 answers
789 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 ...
Matthew Rowlands's user avatar
0 votes
3 answers
279 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 ...
Peleke's user avatar
  • 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: ...
Brandon Doss's user avatar
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 ...
Jake St's user avatar
0 votes
1 answer
625 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 ...
Antonio Santos's user avatar
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 ...
user avatar
-1 votes
1 answer
108 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. ...
Timo's user avatar
  • 39
0 votes
1 answer
360 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 ...
Montag451's user avatar
  • 482
4 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 ...
Sully's user avatar
  • 43
1 vote
1 answer
50 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,...
Ivan Topić's user avatar
14 votes
1 answer
17k 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 ...
Jason C's user avatar
  • 367
7 votes
2 answers
45k 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 ...
Kay's user avatar
  • 203
10 votes
1 answer
18k 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 ...
curious's user avatar
  • 265
9 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 ...
Jonathan Doe's user avatar
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 ...
glenviewjeff's user avatar
  • 1,047
2 votes
1 answer
4k 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 ...
user avatar
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 ...
Tracy Shar's user avatar
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,...
Senduran's user avatar
13 votes
1 answer
16k 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 ?
Michael's user avatar
  • 489
2 votes
1 answer
403 views

Can I get all contributions by users and export them in a csv file in MediaWiki? [closed]

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?
Leena's user avatar
  • 29
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 ...
Paul's user avatar
  • 155
20 votes
2 answers
38k 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 ...
pjmorse's user avatar
  • 303
5 votes
3 answers
9k 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 ...
kjo's user avatar
  • 449
51 votes
6 answers
80k 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 ...
Stan's user avatar
  • 619
2 votes
2 answers
8k 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 ...
Edward Tanguay's user avatar
7 votes
2 answers
26k 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?
leeand00's user avatar
  • 2,193
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 ...
Eimantas's user avatar
  • 243
1 vote
2 answers
382 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 ...
googletorp's user avatar