Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
0
votes
0answers
5 views

How can I export all my orders as a .csv file from Amazon UK (not the US site)

I would like to export all my orders from Amazon UK (not the Amazon.com US site) as a .csv file. I know this is possible on the US site using this: https://www.amazon.com/gp/b2b/reports Is there an ...
0
votes
0answers
21 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 ...
0
votes
0answers
40 views

Twitter's export analytics data delivers an empty CSV

I'm trying to export my Twitter data to see my engagement rate at certain times of the day. This exports as a CSV. I opened this file with Google Sheets, and it only showed column headers with no ...
0
votes
2answers
38 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
77 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
103 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
2k 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
1answer
342 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
425 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
2k 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
84 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
182 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
36 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,...
5
votes
1answer
3k 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 ...
7
votes
2answers
22k 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 ...
5
votes
1answer
6k 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
6k 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
1answer
692 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
1k 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
8k 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
225 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
3k 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
19k 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
5k 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 ...
23
votes
7answers
31k 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 ...
4
votes
2answers
10k 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
336 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 ...