Importing GSTR-1 JSON file in Excel without using any software/website

preview_player
Показать описание
This video tutorial describes steps to use JSON Import (Power Query) of Excel to convert and import data from GSTR-1 JSON file into Excel in tabular form.
Compatibility: Office 365
  1. Excel Kida
Рекомендации по теме
How to Upload 0:10:11

How to Upload the JSon File of GSTR 1 in GST Portal

Importing GSTR-1 JSON 0:04:19

Importing GSTR-1 JSON file in Excel without using any software/website

HOW TO EXPORT 0:02:24

HOW TO EXPORT GSTR 1 JSON FILE FROM TALLY PRIME 4.0 | TALLY PRIME 4.0 TIPS & TRICKS

GSTR-1 JSON import 0:01:20

GSTR-1 JSON import | Winman GST

how to convert 0:04:27

how to convert GSTR-1 JSON file to excel?

How to download 0:10:51

How to download gstr1 from gst portal|Download gstr1 return offline utilities|GSTR 1 JSON file

how to re 0:08:17

how to re export gstr1 in tally prime 4.0 |json file |tally prime gstr 1 json file not showing |

How to prepare 0:03:46

How to prepare GSTR-1 from Tally | Offline GST Return | JSON Import | Quick filing of GST Return

Convert Gstr 1 0:01:38

Convert Gstr 1 Json file To Excel using Tally TDL

GST Offline Tool 0:07:21

GST Offline Tool GSTR 1 | How to File GSTR 1 Offline Excel Utility | GST Offline Tool Error Date HSN

Effortless GSTR-1 Data 0:16:14

Effortless GSTR-1 Data Conversion: JSON to Excel and Tally Import Tool Review!

How to Convert 0:01:28

How to Convert JSON File to Excel File Using Inbuilt Tool | Importing JSON File into Excel

GSTR-1 B2B JSON 0:04:14

GSTR-1 B2B JSON Import & Consolidation into Excel

HOW TO RE-GENERATE 0:01:45

HOW TO RE-GENERATE GSTR1 JSON FROM TALLY PRIME 3.0 | TALLY PRIME 3.0 TIPS & TRICKS

How to file 0:16:40

How to file GSTR-1 through Offline Utility? How to generate JSON file and upload on GST Portal ?

Import GSTR-1 JSON 0:01:46

Import GSTR-1 JSON from Tally | Winman GST

MERGE & CONVERT 0:08:33

MERGE & CONVERT MULTIPLE GSTR1 JSON FILES AT ONCE..!! NO VBA MACRO.NO APP OR CODING.JUST PLAIN E...

gstr1 export in 0:18:51

gstr1 export in tally prime 4.1 |gstr 1 return filing tally json file |gstr-1 json file not showing

How to file 0:04:52

How to file GSTR - 1 from Tally Prime using JSON File?? By Sudhanshu Singh

How to download 0:00:18

How to download GSTR 1 from GST portal in excel | download gstr-1 all data in excel

How to File 0:19:27

How to File GSTR 1 through Offline Utility | How to prepare JSON for GST Return Filing

How to create 0:07:18

How to create JSON file and enter B2B invoice GSTR 1 offline

GSTR1 JSON FILE 0:01:45

GSTR1 JSON FILE UPLOAD FROM BUSY

GSTR-1 JSON to 0:01:11

GSTR-1 JSON to EXCEL Converter

Комментарии
Автор

sir some times I am unable to understand what is the heading of original data, is there any solution for this? for example when json is converted to excel online POS column data is in following format " state code (numeric) - state name" but when power query is used POS column data shows only state code.

GSTR 4A json file I converted as u said using power query, in that one of the columns is gstr 2a filing status by supplier but in power query heading is "colummn 1. cfs". How to understand headings of columns in such circumstances?

Sai-jhti
Автор

i tried this too but Customer Names are not showing in this conversion.. any clue
?

cs.mohitmakhija
Автор

Hi, Is there any chance to get party name also along with GSTIN? Kindly explain..

caumamaheswararao
Автор

How to do the same if more than 1 Json file in a single return, other than doing individual files and consolidating them

aakashmalhotra
Автор

Your MS office Excel variation and price

rockentertainment