Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

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

0
votes
2answers
17 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
0answers
22 views

How do I automatically import one CSV cell to a Google Sheet?

I am a bit of a novice as this will probably be the most complicated thing I have set up so please assume I know nothing. I have an app (App Usage https://play.google.com/store/apps/details?id=com....
0
votes
3answers
62 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 ...
0
votes
1answer
1k 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: ...
0
votes
0answers
9 views

Facebook Store Product Import

My company has started a Store on our Facebook business Page. I would like to be able to import spreadsheets of products for sale to our Store Page rather than manually adding one product at a time. ...
0
votes
1answer
201 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 ...
0
votes
1answer
264 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 ...
0
votes
2answers
1k 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 ...
-1
votes
1answer
65 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. ...
0
votes
1answer
132 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 ...
3
votes
1answer
2k 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 ...
1
vote
1answer
25 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,...
4
votes
1answer
2k 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 ...
6
votes
1answer
17k 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 ...
4
votes
1answer
3k 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 ...
5
votes
2answers
5k 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 ...
2
votes
2answers
4k 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 ...
2
votes
1answer
2k 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 ...
1
vote
0answers
524 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 ...
0
votes
1answer
951 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,...
7
votes
1answer
7k 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 ?
1
vote
1answer
205 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?
2
votes
1answer
2k 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 ...
8
votes
2answers
16k 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 ...
2
votes
2answers
4k 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 ...
19
votes
7answers
26k 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 ...
2
votes
2answers
3k 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
votes
1answer
7k views

What's the biggest .csv file you can import into a Google Sheets?

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?
4
votes
2answers
1k 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 ...
1
vote
2answers
323 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 ...